SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45449 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45449 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689068,702561,176095,609892,930137,28392,720270,163415,297399,848902,944350,772411,794997,723933,948881,259783,558309,350757,767465,7937,1014750,989859,214250,611469,25065,395636,808252,561343,335377,277029,314540,242783,785490,1048809,810820,181973,468079,176714,731927,571416,954589,102170,50554,609787,794103,582745,229057,223891,893238,867579,664867,951649,1046190,619671,293947,984711,486941,659913,1040073,778459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]