SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45363 LIMIT 1 [ RunTime:0.001373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45363 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520508,341817,483804,605224,929082,955174,858331,219319,18649,758929,553433,581814,500099,143443,477594,503848,281774,454170,609171,903641,651780,313060,193259,840046,696398,927824,525011,332216,1012079,122435,434299,972445,681085,282012,596642,297571,689453,134673,411317,485861,49601,108281,706675,515479,47625,418232,890406,103586,234966,352757,481949,827347,202047,1037122,269537,301601,263796,778737,203732,962648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45363 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45363 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]