SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48234 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48234 [ RunTime:0.005141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508134,944738,50184,631361,836019,476945,774006,858600,292727,395343,12529,724022,511029,378000,930150,667975,610333,547718,69885,365279,490131,569392,1022344,485028,574437,958837,809106,477007,788050,607822,405744,640179,189753,818124,643275,1006030,18059,45651,107555,262268,156021,15510,117625,994231,172539,5725,921603,239659,727735,460986,468967,963472,138702,552814,759571,986015,1015039,352756,657397,751008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]