SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231212 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231212 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403614,83923,433744,406884,571852,952480,905010,162817,414071,770766,398999,607820,689239,1028238,451918,796345,900679,110693,97990,765971,264533,496949,113689,603951,60013,317702,481253,633844,839032,766536,1027739,876308,759427,1023333,955731,688439,779750,272928,146605,661521,101983,418867,933994,887754,188538,1470,821628,189312,967588,888772,530554,1007512,865105,477905,899407,906977,284415,156971,137838,104578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]