SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043590 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043590 [ RunTime:0.003817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007947,66855,960103,56732,242772,48577,908502,963467,769177,61762,923134,663564,995433,608086,53804,14181,498816,335837,348658,795926,639852,630391,660948,487209,953121,964087,706341,226596,1038749,1017830,1026759,735444,363770,615869,633264,778669,624874,546145,24781,1026814,506322,170280,846024,761127,10300,956201,674620,253372,442264,583747,580748,220318,259535,122974,588052,930517,642136,193840,441238,578389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001265s ]