SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419703 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419703 [ RunTime:0.003500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015968,843095,199716,764435,339279,319536,347025,65915,321078,956387,360583,104120,721974,832319,478696,754043,842194,918073,442556,1034888,183743,958638,817811,339970,325334,640876,464752,935370,495195,13141,469256,293871,852574,621937,393094,846955,452614,182798,291645,222488,114183,184576,108983,668418,992703,929604,167725,924070,709494,753945,899311,570366,171605,444541,78851,455842,806338,238818,816441,958504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]