SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521568 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521568 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116475,592432,138316,534068,1027182,332883,641001,100591,548205,404368,415207,16915,699209,831881,426812,589330,592320,717262,1035629,675578,743734,291298,731640,103260,368718,201818,383160,617550,1043445,594495,854963,825970,80916,553003,58734,369479,1000039,979495,610371,765110,1024728,371052,885848,802683,970748,108234,770708,352192,313273,280716,847637,135898,130451,825578,191196,259256,817143,949293,985382,741237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]