SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534313 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534313 [ RunTime:0.004960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755135,6871,215305,327024,791674,354445,845604,202942,1015134,398562,164402,199923,991328,90193,468853,866914,1017336,312457,611951,371971,609633,457249,17582,383171,913588,81947,1029910,78791,865180,389483,960094,296475,439979,725160,443562,471548,862424,276108,359643,558971,235410,481121,974926,647562,44844,461366,869676,548268,195104,426550,71165,248824,193528,424021,169304,979216,158241,913978,395591,693948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001353s ]