SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910683 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910683 [ RunTime:0.002883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328336,835610,291367,562579,120467,427735,980794,76065,478401,378378,1028972,232824,254276,857823,412559,345927,903279,217456,386430,57828,239478,866893,289467,870554,523871,67537,769018,605630,593944,988603,477057,121987,833569,849687,668292,1034848,691392,606988,352720,253437,249460,996038,232383,465864,699858,375330,118108,569391,441507,472193,98212,912854,1004523,183595,627583,725329,867482,666308,430921,883091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]