SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037640 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037640 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710602,469549,391419,895183,310503,742419,8926,209137,1044050,420821,143508,284746,628661,529465,74558,854616,345864,158417,457947,177400,552067,620992,19300,93866,381999,280351,490638,650817,476213,828353,31248,477062,1030269,609782,491675,477370,576541,624794,747664,254084,522350,644843,391072,45082,810878,916111,225059,42240,707878,244153,593493,857455,228443,838561,911919,368475,512568,947921,711567,996300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]