SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198883 LIMIT 1 [ RunTime:0.000725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198883 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413081,839449,19099,312895,575182,420174,865493,1041758,693629,114184,870785,497637,1004380,623875,141285,163341,74401,300091,104024,994919,632335,301200,988974,244216,48094,866549,767327,634723,832504,788373,572225,583486,107724,848312,219418,105627,693557,123540,104220,507721,482786,571861,542543,904883,91714,515920,538794,738449,402194,758950,403899,606008,792146,651155,876063,500048,22382,514849,32116,328235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]