SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401012 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401012 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732252,971945,701335,385613,1037606,1025763,614239,603865,926474,281683,578011,282897,326885,818934,58295,954542,814080,277465,631987,266852,234166,93429,833251,956219,669028,566787,265600,661861,887921,41421,699442,240983,959867,210424,517530,201374,881542,783501,61126,693635,166639,952398,550883,60856,170273,833587,419543,234085,398141,862476,166485,13988,681618,720353,207208,933477,763124,866597,827939,441578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001181s ]