SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201549 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201549 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299281,243997,132330,592844,454022,527055,734119,450369,411531,979400,14915,568375,847075,189514,904673,338134,471612,902697,49587,476674,842467,472962,530954,928542,69517,170617,42123,491265,36361,471826,389182,244969,1004789,428736,598289,328770,326449,492285,842195,271859,520161,381738,207616,165505,920598,319349,1029335,521049,230950,946971,692908,353245,511566,672401,528245,926590,176165,740637,225247,781929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201549 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201549 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]