SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292115 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292115 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448742,809618,648985,469011,1019661,852391,403138,735654,738373,100195,883599,614134,223959,598904,633907,489709,350621,785802,802691,704305,358359,259089,741306,449037,689390,616533,426165,783626,856939,543503,808011,902577,243239,352738,882446,364060,462390,440917,948238,86647,433693,743203,543129,261833,850635,115734,745306,30256,910281,466830,411418,36360,805686,312786,383597,964542,585333,163785,317383,25649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]