SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596653 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596653 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613430,485963,418367,278467,560909,412927,875151,653899,842277,405925,7606,864870,491628,883061,306010,960177,848026,859774,32484,878799,297521,297544,736030,81536,895318,493428,148535,565519,173058,678480,630887,668686,252812,690733,363890,884105,940470,546438,646681,691984,7737,126096,16903,851498,409046,521885,331615,525647,460924,704915,400609,43252,42114,408021,416390,616779,118269,19487,845429,291882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]