SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044823 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044823 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038511,24065,961235,909737,323659,977031,351551,863881,640572,964374,106072,760749,941558,235965,11086,469296,570267,912389,936915,117719,611375,122075,770385,239378,244749,259947,261233,893571,882928,297734,554431,272498,215231,908301,1045189,375433,67244,891609,928879,194782,663060,511156,1023156,907631,544284,243508,511269,511355,884043,88400,399098,43519,693871,166726,718508,12172,548550,176822,55237,868153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001672s ]