SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315411 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315411 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113133,1012666,1027875,906089,109118,895089,404042,46123,773523,687415,744438,923201,836288,106210,17422,190569,1045670,455749,703708,494348,487335,961402,655223,73434,117228,8469,68943,240224,133704,395305,157776,487217,48025,381246,160803,627502,180979,92910,769369,314622,801033,208664,149570,241047,465454,791337,666284,365112,973175,505085,917069,250777,467265,954722,48694,235654,628988,434697,764886,726729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]