SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018526 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018526 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037277,872207,566869,716559,279274,279374,83321,327443,984315,304993,502107,569668,1029116,950498,738110,849189,517892,46498,257116,769728,221928,782706,688540,102600,66397,217831,366073,176149,499850,898798,896564,63300,193673,870222,2586,231979,787145,987455,758756,278964,236078,455209,328028,450431,275759,677578,691653,630332,419269,80146,677914,605803,918453,837945,839613,331844,350379,656494,600702,212211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]