SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003833s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971381 LIMIT 1 [ RunTime:0.000952s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971381 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046588,577533,680367,271658,802710,225604,626734,355039,523761,319605,410565,453810,567231,81886,799002,767054,250103,1004027,173878,850660,797701,621339,690563,230425,1014590,568166,441416,474891,411515,386088,65517,220817,796108,255326,392173,89333,954081,631424,951222,931265,481990,636134,976878,1040977,333493,482038,486227,1015297,449876,128248,472631,61663,16456,110694,851667,72540,546836,290894,378911,892292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]