SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023206 LIMIT 1 [ RunTime:0.000737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023206 [ RunTime:0.002556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938731,222716,645275,830244,99180,856551,234987,312385,413826,894620,413396,960239,115429,609147,587552,914015,329782,741000,403613,31306,815218,248756,939981,645018,17725,516078,771054,210385,310959,238848,808511,354514,239113,755750,936694,973493,968702,689734,31578,175830,1024652,75484,890851,472702,903491,749894,262398,279520,778972,401161,718810,496961,63121,958200,166722,855319,454027,729062,511900,491850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]