SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 844023 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 844023 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677064,532920,482654,681102,959782,706473,774890,434554,398235,748148,142259,55125,671102,281599,651985,517733,263939,132107,313652,942101,796206,768640,1014350,555159,90388,545635,497430,459041,14109,485652,599700,312401,409994,317348,880344,946326,404467,527102,677587,68028,316991,939111,699741,622592,589916,196789,693424,362768,911207,324593,505987,81537,397714,345872,391598,378236,145657,545673,837881,912031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 844023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 844023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]