SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52541 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52541 [ RunTime:0.002891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745482,345091,840130,953055,828966,499512,470596,721259,173415,968733,1026238,35695,399217,452120,767704,34031,662453,869260,104436,179557,267826,976072,988655,730708,489635,963452,465637,1045111,802377,490160,11166,840279,953544,858519,809300,646492,909074,456786,23270,111688,296634,409018,528796,795617,665072,54156,971932,304322,66446,887018,664376,104353,1018989,854809,488696,101488,71743,921187,356159,446175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]