SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809998 LIMIT 1 [ RunTime:0.001468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809998 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382168,278518,743526,636341,340597,157653,982470,599094,590017,553401,227889,427842,914611,1001553,915621,554012,52199,124762,828864,8637,569427,987632,417376,752341,843409,101983,950120,685196,627285,775298,155096,488286,129458,859345,251150,75250,224421,793736,620354,15299,537656,811457,50090,632688,906807,1017368,659097,574130,371936,225574,226305,642202,679680,532068,50427,198461,213224,555843,858662,761193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002210s ]