SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004204 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004204 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39195,1342,99531,999642,264729,1035181,796245,751462,998760,527433,568393,731347,880066,768370,27828,212534,991513,156281,85543,684993,99787,85748,303683,207582,195428,582342,368773,108939,308126,287090,372791,555893,62891,433672,390576,559332,364222,597036,804766,998045,977644,371550,164634,894896,916504,80864,452893,117398,804217,1042849,638024,651828,865523,809986,861888,685881,768442,568350,365447,466512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]