SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585530 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585530 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100098,215065,826563,120169,196730,145448,740178,795350,534444,629449,741834,157403,780080,740499,417240,733352,574451,445835,606923,698754,235234,126057,183496,148425,344707,545581,919440,177951,1016968,1029802,495973,401641,167846,45578,846891,1029361,169489,320821,807623,363863,509476,917964,203358,26044,944162,836368,774050,223218,236762,406718,453849,1026284,258074,690989,268202,126277,708305,674259,591534,1032242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]