SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501370 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501370 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887722,891313,237238,456486,643613,519705,632649,60322,830939,745819,1021757,498579,1000658,52875,36147,397971,854803,629110,234278,302821,699906,310736,255872,610641,949823,844173,900797,898906,632788,730095,932315,134681,786609,199129,272581,1039919,114013,6360,362401,314382,617444,787446,130439,229248,964452,475473,308326,439295,970296,145363,504158,426994,604969,384557,905369,683306,177695,965850,105196,229087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000360s ]