SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121048 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121048 [ RunTime:0.003587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028401,532897,951088,731707,586793,965420,662057,260573,1006129,66054,517774,101822,141165,290496,747425,816440,292139,486104,635939,781231,492227,834540,149770,781120,376038,672494,234067,111343,850783,186607,375292,30291,873622,976463,8111,75744,223153,253431,575327,814659,24822,275300,1043996,746744,120224,839917,228754,986049,203375,194253,543670,866068,624002,149750,365712,497770,730556,873561,461009,395614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]