SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102193 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102193 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206486,752491,412278,1021153,257499,459271,565371,385119,695026,382630,660424,285738,310557,958783,908924,146173,365254,619843,971485,280804,46025,643181,246212,122030,595097,353700,943160,503810,712784,1023534,740538,214077,864646,174868,1011203,19425,696019,608531,464314,100680,35518,119449,1038691,517293,46054,19134,658176,889294,395081,176062,58757,382442,376488,642956,367034,462472,735245,528115,955429,159296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]