SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311008 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311008 [ RunTime:0.004882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819509,77611,58660,1044886,728901,170534,660586,95078,143624,300265,541219,788093,707987,113440,305532,136109,215907,537049,373866,485570,634915,483254,600889,405508,729651,894505,860571,269812,1025734,65359,56317,88072,659188,753237,388122,295959,308924,76140,334500,838285,327639,74281,39893,401441,648859,768281,464480,300755,259766,334927,48429,911595,128987,98270,715034,475875,630863,231206,84484,186638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]