SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312910 LIMIT 1 [ RunTime:0.001178s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312910 [ RunTime:0.004432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311607,128427,531985,781274,202233,785865,925622,283797,662559,63169,76407,191528,841165,450474,695120,739485,424310,529724,60469,605212,22979,210216,797947,1033701,258113,721506,203877,785024,79934,157948,853821,119383,1013889,268389,285888,431529,95654,423977,450176,323745,423691,945323,228541,548737,657400,653151,110883,345172,448494,485422,277327,284831,479519,408659,396559,676779,671685,248825,824399,976943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]