SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991021 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991021 [ RunTime:0.004926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626413,138767,569204,672334,360870,939565,445513,125361,86928,127356,341915,965101,126715,382032,91698,187464,348393,401785,368389,332365,597603,501182,804224,263072,296222,181994,407745,388509,22746,621338,601228,981422,470847,966410,367932,724009,446452,562235,629928,584092,658755,635598,450408,87761,378929,365747,290114,57336,763486,634757,878184,342562,971625,278619,911171,790293,172017,199886,181894,30146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]