SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512926 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512926 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010984,173851,270490,360484,796254,104545,160843,583572,177118,634528,1021938,381134,732513,764476,644706,907500,395738,966602,616833,1041991,177645,13364,412074,112426,1017942,646262,214106,27174,853048,243644,885276,595512,35460,969936,720787,291956,157983,451656,607443,906024,742084,232862,24772,953109,587045,702898,22366,410371,885974,557740,561376,779697,523965,503068,650952,377007,1003378,766189,831612,774905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]