SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495532 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495532 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511555,396897,93357,205891,1028293,886249,21510,862105,479785,832592,160983,834802,899630,244441,467918,1003540,253745,1001608,1042709,644969,949963,601890,289589,966475,829614,410200,980827,454528,128721,545871,986657,519235,916008,722020,228563,932618,257673,802727,981952,766125,683223,490205,455343,337085,657510,742540,1037414,550670,561380,853019,340312,807553,26374,976197,919780,498812,289728,375661,532082,409248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]