SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541857 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541857 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477916,728947,852138,513084,17208,527028,542803,324059,117862,583504,985557,962386,131006,16821,1044380,729778,358357,96158,696906,835558,503272,749336,71863,1016349,246156,727102,11706,314348,428320,847578,176270,323323,223007,171999,298316,951423,9221,740267,735031,697686,676349,466574,340342,842001,304399,49769,648395,477511,543376,208327,708228,150738,6039,95320,611833,421894,262825,49457,487021,88846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]