SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400358 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400358 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607047,609423,984296,394398,484164,449301,613419,159026,742913,692607,930861,901195,264173,781323,324581,67438,792123,753270,362716,559887,508368,343424,302286,543958,441235,791523,473647,134357,478546,606571,336464,886519,976882,708951,648434,231908,261257,216176,987812,947169,178295,730506,601840,726027,9266,165318,23337,549685,695830,576312,667205,613323,96312,844977,496737,375804,573140,731297,619650,956489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]