SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241380 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241380 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545120,644349,631259,603610,142878,981851,433716,879791,478908,334774,459128,650125,698310,286367,795461,876589,657077,1007307,56883,485650,249124,686445,11898,119734,996177,718893,465824,943576,766203,378302,183512,801223,381649,476082,948389,77000,1012400,48269,401254,56053,840567,345487,672457,639985,134326,179117,533023,61355,549803,502678,26910,904190,846796,828340,491462,402419,1029652,302017,790605,738742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]