SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001700s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206640 LIMIT 1 [ RunTime:0.000958s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206640 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473050,128236,293778,864394,1041495,394305,78818,522500,774579,589737,946763,864676,963443,261801,621096,44690,959611,265884,578891,89429,467582,69263,747074,243420,844797,170456,848747,19391,333006,834114,671018,878239,689586,516329,235011,1045144,43086,771307,922058,314020,519804,6505,478556,252866,86719,249294,400306,209857,302523,341682,283343,634359,724895,23451,15842,159679,152809,166596,298649,370901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002084s ]