SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003193 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003193 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860396,327007,494261,956694,832075,1043979,338846,844867,1978,1042998,303569,732164,638790,294634,36441,367034,839459,53104,782976,399743,923594,757684,444468,1028643,472029,462606,502322,197167,652260,51133,114562,79821,923990,992991,441437,811724,933043,99198,967307,866604,81310,874901,141467,948656,488692,666671,909025,464345,579735,979009,204049,99701,491434,462473,413022,198614,360828,322464,266826,1040092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]