SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405741 LIMIT 1 [ RunTime:0.000810s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405741 [ RunTime:0.002408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664735,110927,7982,505317,513002,585351,772479,583131,906227,692312,28355,172181,674663,718158,424039,917625,334406,120764,648910,893582,1028841,981142,653494,338811,71632,399366,955603,120588,110890,642950,370430,689851,893122,995955,1030895,507844,179936,951228,857950,950618,361616,588379,196936,176486,314770,554308,566669,185837,322580,330599,789846,633550,906219,445698,690263,649384,1047773,410654,8381,279407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]