SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582006 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582006 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821737,1047240,407040,303170,454223,1025933,813668,119838,1023193,241106,142336,455991,509416,574927,680086,412209,199096,481242,115057,839486,733811,206934,372348,496821,618066,88872,985037,619127,312746,365847,95237,384707,520404,280193,89460,999455,827909,311410,645109,142121,765848,36680,891103,1035005,32076,733775,108092,255648,282524,40909,978135,604917,151887,402764,145260,184458,897808,521227,416953,234934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001210s ]