SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018564 LIMIT 1 [ RunTime:0.001539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018564 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670173,191207,958258,491151,453908,1046289,522632,811893,832192,932648,351326,612756,174282,296756,921321,660247,315301,905923,488421,26112,5448,184036,768108,827546,413140,1007256,272855,911774,558777,499964,381689,933960,432647,929805,39905,742962,208535,435692,879371,1047432,301602,889631,1040183,955962,183340,285428,693279,32346,245066,228037,1048128,822265,887321,878582,221744,253775,228444,927281,970599,119886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]