SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524653 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524653 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358589,1024069,963542,827210,221930,257642,4896,110315,434960,454223,504148,956429,332544,610681,418072,143572,825986,590934,941651,1007451,726895,842061,273320,280496,705944,56010,965655,208366,981478,675952,883334,972936,983991,857542,1015956,564288,97024,785614,597721,162641,524258,787916,1039470,993474,590378,1027776,738230,100433,788012,621789,279146,688469,670111,863896,353243,205077,922868,515728,566454,278454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]