SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104823 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104823 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86987,199177,852491,258609,334039,389538,174513,238643,923529,487329,126553,579108,378130,418989,625346,115947,701396,1020076,973023,913427,406195,626504,764506,420858,856174,669750,59798,616749,287425,726190,608417,177637,1021140,985271,618043,308098,920072,442789,409886,486025,242146,667360,200950,622199,839711,754201,589842,554024,324511,62431,352116,577973,580888,767737,416213,804196,810921,218114,1010837,588953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]