SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499217 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499217 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619116,819149,926557,346968,1023149,134693,230583,671597,490423,692851,1018207,667098,877059,133346,769,853913,101850,269785,56926,141306,679841,1012210,346406,986531,141273,343993,914823,630661,952081,872298,1036425,586802,107926,99766,554323,415985,324937,121707,643399,947155,807796,963360,856870,955916,575218,165410,235151,585057,211520,172131,571999,250681,346194,913334,102086,812240,179370,595161,54768,294742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]