SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002392 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002392 [ RunTime:0.003426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514403,871400,277757,499587,9158,675666,865272,129390,972110,189854,213821,1045757,211496,280261,829576,245350,135130,75776,709084,1881,880117,948982,332663,413891,540684,934531,89081,386177,1048318,609877,330708,380353,876154,149733,376108,404986,560841,463942,107136,577414,795925,648268,535101,833617,355257,666680,194823,573296,808214,701616,50740,48622,323929,211570,641637,3254,644977,386139,890335,64504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]