SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370084 LIMIT 1 [ RunTime:0.000646s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370084 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029614,217306,732849,810164,436408,139607,813407,727834,73942,466367,637500,156778,606773,711844,120790,663763,994216,78150,685822,834178,923599,926464,213352,159070,129611,658565,504553,301421,253798,809975,148168,18857,295328,500836,344272,182351,600681,557103,656381,3189,549950,399466,911543,273919,269359,858254,510402,991632,127614,453312,822166,335839,574580,872530,383617,995406,611260,308006,704453,332583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]