SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042688 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042688 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647095,1040981,42631,458627,601556,961779,227588,292119,619126,1024037,296630,190449,42593,766087,826887,603695,352685,569969,477301,114982,932826,371534,607154,311541,1005844,683226,44188,144589,4052,473412,92007,185081,919541,629041,832316,454406,417951,400764,862356,565273,432306,274905,814675,83637,930659,721695,220968,399100,991801,912951,802141,309450,358046,953530,826132,177656,279962,1019832,1020600,839671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]