SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436983 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436983 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951019,28245,45459,525364,816421,671844,977888,160269,420779,806018,651963,730064,587014,841156,762722,986125,981241,264843,517817,443152,263898,523627,767864,559218,816066,47338,686427,286707,115622,681171,977678,1009550,362599,929540,657488,1004529,622204,543256,452813,221776,875315,1024041,215152,814132,1035990,607262,522225,1045611,558907,646371,691482,733578,629018,339962,1008555,855544,126028,798429,563991,675534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]