SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507412 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507412 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682270,896655,9731,899357,471067,756687,26189,1044567,496198,966637,484272,691844,857547,672071,545982,377003,618556,645434,432871,443346,835264,333216,739055,381136,317448,335842,479969,890540,597505,849298,747595,423408,790624,455791,217331,974206,238944,851876,71112,89651,375464,486466,793400,84915,13113,703104,627731,752851,948496,782203,445948,370068,548393,358347,306106,136580,917771,710153,260484,1018155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]