SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040203 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040203 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52852,743235,650757,974923,178546,812450,400289,517403,220265,162460,489893,263954,83524,864117,772591,733170,145241,492978,454683,435209,73764,313750,254691,649836,223313,57448,784814,396248,898364,794861,900731,849524,565363,50829,442913,96758,782536,169713,692451,10593,816692,983904,39186,316696,334388,552730,309228,303110,555389,221992,149106,178742,281632,441497,1000556,239478,912303,1018012,3783,432435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]