SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404880 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404880 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372276,763435,934922,459574,894924,701824,25609,105290,691188,121736,958451,194019,243780,76374,275069,757838,593766,569528,359372,964571,96792,235633,679150,239610,209768,808697,478657,437309,541342,79186,941364,923355,287054,556619,828406,1036271,531878,836916,742143,1008251,754655,947737,920836,607148,959390,426428,891620,863683,1029747,698605,719326,514925,702623,914913,685245,309177,458836,242675,811692,794053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]