SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527001 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527001 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50471,1030535,609557,168486,47099,981271,339929,315803,1030175,182912,846812,631384,151690,723128,572375,482380,884401,1520,263058,523198,861054,692029,312079,937493,957166,668613,93427,466402,479499,850361,457807,945592,493846,237948,2069,707144,399581,404298,637951,985060,709522,531684,49915,863171,378980,494668,305239,826834,177403,77398,984818,442827,876867,34103,330277,156255,656905,149769,278627,677773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000882s ]