SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367019 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367019 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380036,212420,506566,1024768,225376,482871,796512,379988,607913,109611,383274,637609,31569,1017965,199096,683236,685144,321676,1025869,359162,219253,862898,525536,599759,414963,977447,28843,559543,381864,571612,106371,131976,871831,90656,947787,520380,125087,107843,1044678,232040,694705,451592,389102,939971,216838,37645,326522,878666,280660,329506,610679,504487,469847,428305,697977,684358,415709,730387,994075,477301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]