SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642013 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642013 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659077,42197,997042,390854,9703,224892,357807,185390,358677,1038020,867001,986469,521932,754924,3176,432307,143451,736405,961326,919253,433705,707897,233336,370264,551831,653693,194718,547545,443916,224037,241235,308116,55928,713037,400147,219,344262,531637,51119,439115,660399,430053,872303,588247,420403,981427,789098,199786,399332,521395,962227,594344,693700,712933,277878,229446,426495,938748,495029,834045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001034s ]