SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490281 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490281 [ RunTime:0.002960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232980,273589,951682,603043,433411,231471,624059,100958,90719,441373,756196,52140,282051,102584,591519,743417,380414,506294,309153,1024989,778016,931361,207266,650464,641921,147388,104435,1039769,762185,646895,1019759,545256,888956,569958,985796,532753,840242,905155,293017,125331,38528,303708,291678,244189,163649,1022919,572157,163122,409276,531809,920566,380858,963808,814741,759030,891753,817169,455282,473976,279343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]