SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204109 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204109 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197394,208578,685580,401067,1038401,148449,859178,442351,243691,756893,991526,316346,81499,26127,110447,329716,43324,942179,149445,1029673,826104,448915,217243,199418,1032619,899782,577620,245435,260038,130561,300379,446946,824761,999295,195321,420164,736437,1023687,455845,101535,152228,581558,40723,141027,207107,686513,543021,416134,428284,1046696,435759,292396,417756,207171,636156,831448,844041,726492,294823,663480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]