SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505922 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505922 [ RunTime:0.003197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32591,451977,855570,278112,722918,219987,429344,864377,705427,16734,657464,427773,520995,564605,963123,404834,138389,798386,444481,692367,257192,590340,123603,773645,447335,217215,339008,126882,137309,40870,1015128,446818,102007,731366,374697,659699,733560,451655,411315,505356,562423,630361,283774,961215,428506,925047,410131,127520,295675,924452,10887,631751,465702,599039,785293,458880,868232,831938,1038602,677343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]