SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545502 LIMIT 1 [ RunTime:0.000619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545502 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801720,360613,504009,549046,185231,633922,862871,860447,169789,977449,252882,149270,108013,702113,934295,1017263,1018994,911306,379853,161592,14363,91581,649729,409350,853636,758556,635795,388547,1547,696028,750504,337301,304524,372759,919100,571805,360683,363065,204242,274339,756481,254205,1300,296449,495187,883195,942816,221015,493935,197849,497304,27908,288999,390775,778740,758014,306626,983985,623354,47625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]