SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806960 LIMIT 1 [ RunTime:0.000934s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806960 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313015,677317,641611,606332,712456,771799,298326,125894,66311,575874,227810,13604,941628,848016,360239,701036,87223,699104,994252,384627,293358,229007,289563,925128,234025,441601,772019,6930,691853,424548,848391,72990,277500,564063,480238,358733,157523,479074,826779,324619,268055,111581,689033,324442,168878,864744,824842,675457,180073,466428,796421,686584,994723,306309,446589,878102,144615,168647,728011,581657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]