SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003945 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003945 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541237,186198,328037,943808,924107,716274,268211,676086,453112,290582,702056,844934,667689,762007,200109,998930,236153,392574,690895,723300,830704,739106,945031,140782,885099,790994,349047,578146,774674,79929,306254,65711,888795,97995,316399,178799,277776,811783,317872,259535,125124,938614,114106,192577,422901,543158,743779,651021,601219,108216,558649,601757,112310,521199,381506,618490,958598,982506,994571,607862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]