SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114917 LIMIT 1 [ RunTime:0.003625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114917 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284817,76208,323454,172457,153817,125170,296774,288786,561776,360188,676576,650465,544200,802503,77922,145658,979712,536780,192540,386579,53596,370683,795478,779397,1028377,530489,68768,190719,683233,796411,988484,504567,1025687,272530,955716,603191,341081,139280,745775,507349,993568,178651,529674,142974,178545,381064,537317,563228,345359,823274,141893,537229,384532,950118,602344,906879,249503,659334,133981,186341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001699s ]