SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397421 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397421 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510390,604686,605158,1015766,211672,597651,906060,52836,834590,473482,995603,1032675,686570,384751,356223,762302,1003617,847593,530898,35435,833065,505459,432687,1042318,577725,44017,46219,92286,182175,74579,345141,274787,956289,689125,147735,543520,636116,410519,569771,536244,643410,243168,325390,647419,754245,536088,8510,741212,165680,991825,1017368,1016049,60782,44783,634324,1024469,777911,150248,497144,384202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]