SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543271 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543271 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876413,688278,482683,676809,47942,618849,115727,447625,1018100,759942,19020,1044818,589890,720836,298835,326648,846326,766777,382940,20,954670,657520,738441,349515,343955,695054,404826,877706,515387,938779,422057,1021785,57707,906355,283601,403054,1019806,376892,154087,917713,688395,932780,532587,87055,218871,562898,118615,749067,484344,52614,160709,159614,372853,1028466,748677,867273,893122,314792,547904,703722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]