SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261757 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261757 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525938,389379,919474,960636,1041872,525342,692326,562018,945754,126498,990427,640827,388625,547372,805777,275414,1001825,602846,872818,759339,686600,141189,845671,340129,1007765,1028468,832743,70515,64004,53949,95600,413765,608986,67108,377339,24044,338814,154667,530759,212008,473876,936625,342652,1020974,377337,223657,794491,184757,543649,134607,422838,250790,263445,235597,166762,217871,95267,308860,29070,644152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261757 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261757 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]