SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411751 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411751 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194127,946915,230699,258576,787418,98603,725899,603897,334016,80983,665366,588581,816282,371427,736024,440594,312339,1024809,338751,268300,776467,718036,321626,752552,454241,500888,129551,487997,25491,204954,574386,343655,805362,843852,758734,411690,76448,512924,819417,742933,154369,800641,313322,77089,76255,459766,730684,250261,838838,638267,807703,176872,950073,115458,1039675,384453,303471,514718,635906,315473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]