SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027102 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027102 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636064,1036170,513667,822753,298411,555475,427594,563657,83431,153821,547846,443779,88367,59330,691703,712155,386740,29810,817524,184151,496352,134247,132433,278701,722052,34020,653103,913110,825543,700050,117738,16344,348338,764499,571509,579937,305095,997707,806863,745907,587471,775485,295914,726042,885754,38001,123260,410023,830827,376264,326019,548608,1017963,76864,500077,800748,441191,577479,158239,685030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]