SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47190 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47190 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915980,558010,920516,1952,581018,674633,739232,810167,221775,657575,293959,191442,572337,94396,474090,706559,233532,811548,163797,879872,632081,141350,424259,145807,553384,737275,110985,509502,175947,348908,123690,915547,635317,162290,351538,917887,213285,47414,73288,1032395,56373,1006726,1002187,466032,319242,813400,617239,489090,350956,31652,672653,520637,550824,303682,222001,177008,893759,665734,460970,712644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002766s ]